Design and modeling of a hybrid database schema: transactional and analytical

Os sistemas de bases de dados em contexto organizacional estão segmentados em duas categorias: bases de dados operacionais e bases de dados analíticas. Como consequência da constante evolução tecnológica, vários esforços foram levados a cabo com o objetivo de reavaliar o paradigma atual. Assim, a conceção de bases de dados híbridas capazes de suportar o processamento transacional e analítico é vista como possível e viável. No entanto, é clara a presença de uma lacuna no que diz respeito à existência de abordagens que demonstrem como modelar esquemas conceptuais para este tipo de bases de dados. Neste póster é apresentada uma conceção e modelação de um esquema lógico de uma base de dados híbrida.Database systems in organizational context are segmented in two categories: operational databases and analytical databases. Several efforts have been undertaken to re-evaluate the current paradigm, based on the constant technological evolution. Thus, the design of hybrid databases, capable of supporting transactional and analytical processing is possible and feasible. Even so, it is clear a gap about the existence of approaches regarding the modelling of conceptual schema for this type of databases. In this poster, is presented a logical schema for a hybrid database.(undefined)info:eu-repo/semantics/publishedVersio

Process-based information systems development: taking advantage of a component-based infrastructure

Background: Owing to the highly competitive business environment in which contemporary organizations have to operate, a quick and effective way of developing and maintaining information systems is of utmost importance to their success. Obviously, the computerized information systems that support the everyday operations and management of organizations play a critical role in their competitiveness. For that reason, nowadays, more than ever, information systems have to be quickly developed, rapidly reconfigured, and easily maintained. Objectives: We aim to define a technological infrastructure, accompanied by a set of methodological development requirements, which might help to fulfil those needs. Methods/Approach: In this work, we followed a Design Science Research (DSR) approach. Results: We propose a specific IT infrastructure, inspired by the concept of a business process and using the functionalities provided by collaborative and workflow technologies, which allows the development of distributed IT solutions, Process-Based Information Systems (PBIS), in a component-based fashion. In the context of PBIS, we also propose a set of development requirements. Conclusions: We claim that Process-Based Information Systems allow organizations to evolve quickly and smoothly in face of changing business requirements, facilitating the integration of existing and future IT artefacts, while simplifying the overall development and maintenance effort of information systems.info:eu-repo/semantics/publishedVersio

The development of process-based information systems: methodological requirements

At the present time several issues are dramatically challenging the way we build and maintain information systems. On the one hand, owing to the extremely competitive conditions and dynamics of the business environment, it is vital for organisations to be able to develop and modify their information systems as quickly as possible, in order to succeed or even to keep in business. On the other hand, new technological developments have recently brought to the information systems infrastructure a set of new technologies with enormous potential to improve the way information systems support organisations. Collaborative technologies and, in particular, workflow, are notorious examples. In this paper, we propose a new information systems framework (Process-based Information Systems), which is able to provide organisations with the means to respond timely and adequately to the opportunities and threats of the business environment. Regarding this framework we try to identify the limitations of conventional Information Systems Development methodologies and, therefore, propose a set of new methodological requirements.COMPETE: POCI-01-0145-FEDER-007043 and FCT - Fundação para a Ciência e Tecnologia within the Project Scope: UID/CEC/00319/2013info:eu-repo/semantics/publishedVersio

Automatic classifier of scientific contents

The growth of scientific production, associated with the increase in the complexity of scientific contents, makes the classification of these contents highly subjective and subject to misinterpretation. The taxonomy on which this classification process is based does not follow the scientific areas' changes. These classification processes are manually carried out and are therefore subject to misclassification. A classification process that allows automation and implements intelligent algorithms based on Machine Learning algorithms presents a possible solution to subjectivity in classification. Although it does not solve the inadequacy of taxonomy, this work shows this possibility by developing a solution to this problem. In conclusion, this work proposes a solution to classify scientific content based on the title, abstract, and keywords through Natural Language Processing techniques and Machine Learning algorithms to organize scientific content in scientific domains.This work has been supported by IViSSEM: POCI-01-0145-FEDER-28284

Machine learning and natural language processing in domain classification of scientific knowledge objects: a review

The domain classification of scientific knowledge objects has been continuously improved over the years. Systems that can automatically classify a scientific knowledge object, through the use of artificial intelligence, machine learning algorithms, natural language processing, and others, have been adopted in most scientific knowledge databases to maintain internal classification consistency as well as to simplify the information arrangement. However, the amount of available data has grown exponentially in the last few years and now it can be found in multiple platforms under different classifications due to the implementation of different classification systems. Thus, the process of searching and selecting relevant data in research studies and projects has become more complex and the time needed to find the right information has continuously grown as well. Therefore, machine learning and natural language processing play an important role in the development and achievement of automatic and standardized classification systems that will aid researchers in their research work.This work has been supported by IViSSEM: POCI-01-0145-FEDER-28284

Data Feminism Influence on Data Visualization

Data Visualisation is currently seen as a powerful communication tool, as the human mind is more receptive to visual information than words or raw data. However, most existing visualisations are done from an androcentric perspective. This article proposes Data Visualisation from a feminist perspective. To this end, concepts such as Feminism, Data Visualisation and Data Feminism will be addressed to arrive at the concept of Data Visualisation in Feminism, resulting in a set of guidelines and recommendations to be incorporated when designing Data Visualisations. As part of the work carried out, an existing data visualisation was selected and analysed, highlighting the guidelines of Data Feminism in Data Visualisation. As a result, a recreation of this visualisation is proposed, incorporating the Data Feminism guidelines. It was found that the resulting visualisation is different from the original and is aligned with the concepts of Data Feminism

Baby steps in E-health: Internet of things in a doctor's office

IoT is a very common buzzword in e-Health because the creation of new and better healthcare services are possible through technology-push. There are great expectations in using IoT in healthcare, but most studies describe very futuristic and disruptive solutions for the healthcare real world. In a near future these solutions could be implemented, but now we need some “baby steps” to reach an e-Health with IoT technology. In this paper it is presented a solution to transform a doctor’s office in an IoT office by helping the doctor attend a patien. This solution has impact in the doctor’s work because (s)he has a limited time to attend a patient and a big part of this time is spent writing the results of the appointment in a computer record - the electronic patient record. By other hand the patient improve their experience because the doctor will give them more attention and care.This work has been supported by COMPETE: POCI-01-0145- FEDER-007043 and FCT (Fundação para a Ciência e Tecnologia) within the Project Scope: UID/CEC/00319/2013 and project QVida+: Estimação Contínua de Qualidade de Vida para Auxílio Eficaz à Decisão Clínica, NORTE‐01‐0247‐FEDER‐003446, supported by Norte Portugal Regional Operational Programme (NORTE 2020), under the PORTUGAL 2020 Partnership Agreement, through the European Regional Development Fund (ERDF).info:eu-repo/semantics/publishedVersio

Internet-of-Things: strategic research agenda evolution

Em 2007 foi constituído o European Research Cluster on the Internet of Things, com o objetivo de abordar o grande potencial de recursos baseados em Internet of Things na Europa e coordenar a convergência das atividades em curso. Esta instituição publica periodicamente Agendas Estratégicas de Investigação com previsões de tópicos de desenvolvimento e investigação tanto a curto, médio e longo prazo. É objetivo deste artigo, estudar essas Agendas e efetuar um levantamento dos tópicos, de forma a perceber a sua evolução ao longo do tempo, isto em termos de áreas que foram já investigadas (ou que a investigação já foi iniciada) bem como aquelas ainda não foram exploradas.The aim of European Research Cluster on the Internet of Things, established in 2007, is to address the large potential for Internet of Things-based capabilities in Europe and to coordinate the convergence of ongoing activities. This organization regularly publishes Strategic Research Agendas with short, medium and long term forecasts of development and research topics. The aim of this paper is to study these agendas and make an identification of topics, in order to understand its evolution over time, that in terms of areas that have already been researched (or the research has already started) as well as those not yet explored.Este trabalho foi financiado pelo projeto QVida+: Quality of Life Continuous Estimation for Effective Clinical Decision Support, Nº2015/003446 P2020 SI I&DT, (NUP, NORTE-01- 0247-FEDER-003446). Foi também suportado pela OptimizerLda, e pelo COMPETE: POCI-01-0145-FEDER-007043 e FCT – Fundação para a Ciência e Tecnologia UID/CEC/00319/2013Optimizer, Ldainfo:eu-repo/semantics/publishedVersio

Data analytics for data variety

A internet fez com que os gestores das organizações tivessem acesso a grandes quantidades de dados e esses dados são apresentados em diferentes formatos, em concreto, estruturados, semiestruturados e não estruturados. Esta variedade de dados é essencialmente proveniente das redes sociais, mas não só, também são provenientes da Internet of Things. Verifica-se para os dados estruturados que existem técnicas validadas, estudadas e maduras, mas para os outros tipos de dados, ou seja, semiestruturados e não estruturados tal já não se verifica. Neste poster, é apresentado um conjunto de técnicas de análise de dados para os dados semiestruturados e não estruturados, utilizando como principal bibliografia conferências de investigação na área de análise de dados.Through the Internet, the organizations managers had access to massive amounts of data and these data are presented in different formats, namely, structured, semi-structured and unstructured. These variety of data is essentially generated from social networks, but not only, they also are generated from the Internet of Things, from machines, sensors, among others. While the structured data has techniques well studied, mature and validated, otherwise the other types of techniques, semi-structured and unstructured, this is no longer true. In this poster, a set of data analysis techniques is presented for the semi-structured and unstructured data by using as main bibliography data analytics conferences.(undefined)info:eu-repo/semantics/publishedVersio

Exploring data analytics of data variety

The Internet allows organizations managers access to large amounts of data, and this data are presented in different formats, i.e., data variety, namely structured, semi-structured and unstructured. Based on the Internet, this data variety is partly derived from social networks, but not only, machines are also capable of sharing information among themselves, or even machines with people. The objective of this paper is to understand how to retrieve information from data analysis with data variety. An experiment was carried out, based on a dataset with two distinct data types, images and comments on cars. Techniques of data analysis were used, namely Natural Language Processing to identify patterns, and Sentimental and Emotional Analysis. The image recognition technique was used to associate a car model with a category. Next, OLAP cubes and their visualization through dashboards were created. This paper concludes that it is possible to extract a set of relevant information, namely identifying which cars people like more/less, among other information.COMPETE: POCI-01-0145-FEDER-007043 and FCT - Fundação para a Ciência e Tecnologia within the Project Scope: UID/CEC/00319/201